Create Table Student(
	
	StudentID char(7) PRIMARY KEY,
	Name nvarchar(50) NOT NULL,
	Age int,
	Address nvarchar(80),
	Gender char(1),
	Batch char(3) NOT NULL,
	Image varchar(80),
)

Create Table Manager(
	Username varchar(20) PRIMARY KEY,
	Password varchar(20) NOT NULL,
	Email varchar(30) NOT NULL,
	Role bit NOT NULL,
)
 
INSERT [dbo].[Manager] ([Username], [Password], Email, [Role]) VALUES (N's0ulHs', N'1234', 'ducndse03296@fpt.edu.vn', 1)
INSERT [dbo].[Student] ([StudentID], [Name], [Age], [Address], [Gender], [Batch], [Image]) VALUES (N'SE03295', N'Nguyen Hoang Linh', 20, N'asd', N'M', N'8C ', N'ads')
INSERT [dbo].[Student] ([StudentID], [Name], [Age], [Address], [Gender], [Batch], [Image]) VALUES (N'SE03296', N'Nguyen Duy Duc', 18, NULL, N'M', N'8B ', N'sa')
